TOURISM DATABASE MANAGEMENT SYSTEM USING DATA WAREHOUSE APPROACH

  • Type: Project
  • Department: Computer Science
  • Project ID: CPU2097
  • Access Fee: ₦5,000 ($14)
  • Pages: 65 Pages
  • Format: Microsoft Word
  • Views: 351
  • Report This work

For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853



  ABSTRACT

Tourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector of the above named countries has served as a source of employment for the citizenry in various capacity.

In reflection of the above statement, this thesis will be centric on the proposal for developing a tourism database management system using warehouse approach for the Nigeria government. The system will be developed basically to give reports related to the tourism sector.






















Table of contents


CHAPTER ONE: INTRODUCTION12

1.1 INTRODUCTION12

1.2 AIM13

1.3 OBJECTIVES13

1.4 PROBLEM STATEMENT14

1.5 SCOPE14

CHAPTER TWO: LITERATURE REVIEW15

2.1 INTRODUCTION15

2.2 BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA16

2.3 THREE TIER DATA WAREHOUSE17

2.3.1 BOTTOM TIER18

2.3.2 MIDDLE TIER18

2.3.3 TOP TIER19

2.4 THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM19

2.4.1 CHARACTERISTICS OF DATA WAREHOUSE19

2.4.1.1 SUBJECT ORIENTED WITH19

2.4.1.2 UNIFIED:19

2.4.1.3 TIME VARIATION20

2.4.1.4 NONVOLATILE:20

2.5 CLOUD COMPUTING20

2.6 BIG DATA COMPUTING21

2.7 DATA WAREHOUSE IN EGYPTIAN TOURISM22

2.7.1 ANALYSIS OF DATA SOURCES22

2.8 DATA WAREHOUSE IN CHINA TOURISM23

2.9 DATA WAREHOUSE IN ROMANIAN TOURISM24

CHAPTER THREE: REVIEW OF TECHNOLOGIES26

3.1 INTRODUCTION26

3.2 Oracle Database 11g26

3.2.1 ORACLE APPLICATION EXPRESS27

3.2.2 INTERACTIVE REPORT29

3.2.3 FLASH CHARTS31

3.2.4 DYNAMIC ACTION32

3.2.5 TRIGGER32

3.3 ETL (EXTRACTION, TRANSFORMATION AND LOADING)33

3.4 CONCLUSION34

CHAPTER FOUR: PROPOSED METHODOLOGY35

4.1 SYSTEM METHODOLOGY35

4.1.1 REQUIREMENTS PLANNING PHASE36

4.1.1.1 PROPOSED SYSTEM REQUIREMENTS37

4.1.2 USER DESIGN PHASE38

4.1.3 CONSTRUCTION PHASE38

4.1.4 IMPLEMENTATION PHASE38

CHAPTER FIVE:  PRODUCT DESIGN39

5.1 INTRODUCTION39

5.2 ENTITY RELATIONSHIP DIAGRAM (ERD)39

5.3 USE CASE DIAGRAM40

5.3 STAR SCHEMA41

5.4. DATA FLOW DIAGRAM (level 1 diagram)42

5.4.1. STAFF DATAFLOW DIAGRAM42

5.4.2 TRAVELER DATA FLOW DIAGRAM43

5.4.3 ADMIN DATAFLOW DIAGRAM44

5.5 CONTEXT DIAGRAM45

5.6 ACTIVITY DIAGRAM FOR TRAVELER, STAFF AND ADMIN46

5.7 DATA DICTIONARY FOR ENTITY RELATIONSHIP DIAGRAM47

5.8 STAR SCHEMA DATA DICTIONARY50

CHAPTER SIX:  PRODUCT IMPLEMENTATION AND TESTING52

6.1 INTRODUCTION52

6.2 THE CONSTRUCTIVE PHASE OF THE PROPOSED SYSTEM52

6.3 REQUIRED PLAN FOR THE PROPOSED SYSTEM52

6.4 THE SYSTEM DEVELOPMENT ENVIROMENT52

6.4.1 HARDWARE52

6.4.2 SOFTWARE REQUIRED FOR THE PROPOSED SYSTEM DEVELOPMENT53

6.5 IMPLEMENTATION OF THE PRODUCT54

6.5.1 PROPOSED SYSTEM INTERFACE54

6.5.2 The login page55

6.5.3 Valid user login page55

6.5.4 Home page56

6.5.5 Graphical analysis on traveler56

6.5.6 Graphical analysis on transportation57

6.5.7 Graphical analysis on location57

6.5.8 Graphical analysis on accommodation58

6.5.9 Historical data (data warehouse)58

6.6 Testing of product59

6.7 CONCLUSION59

CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION60

7.1 INTRODUCTION60

7.2 EVALUATION OF PRODUCT60

CHAPTER EIGHT: SUMMARY61

8.1 INTRODUCTION61

8.2 INFORMATION GATHERING61

8.3 RESULTS62

8.4 FUTURE ENHANCEMENT62

REFERENCE62
















Lists of Tables


Table 5.1

Table 5.2

Table 5.3

Table 5.4

Table 5.5

Table 5.8.1

Table 5.8.2

Table 5.8.3

Table 5.8.4
















List of figures

Figure 2.1----------------------------------------------------------------------------------18

Figure 3.1----------------------------------------------------------------------------------26

Figure 3.2----------------------------------------------------------------------------------27

Figure 3.3----------------------------------------------------------------------------------29

Figure 3.4----------------------------------------------------------------------------------30

Figure 3.6----------------------------------------------------------------------------------30

Figure 3.7-------------------------------------------------------------------------------------------31

Figure 3.8-------------------------------------------------------------------------------------------31

Figure 3.8-------------------------------------------------------------------------------------------32

Figure 3.9 ----------------------------------------------------------------------------------33

Figure 5.1-----------------------------------------------------------------------------------39

Figure 5.2-----------------------------------------------------------------------------------40

Figure 5.3-----------------------------------------------------------------------------------41

Figure 5.4-----------------------------------------------------------------------------------42

Figure 5.5-----------------------------------------------------------------------------------43

Figure 5.6-----------------------------------------------------------------------------------44

Figure 5.7-----------------------------------------------------------------------------------45

Figure 5.8-----------------------------------------------------------------------------------46

Figure 6.5.2.1------------------------------------------------------------------------------55

Figure 6.5.2.2------------------------------------------------------------------------------56

Figure 6.5.2.5------------------------------------------------------------------------------57

Figure 6.5.2.6-----------------------------------------------------------------------------58

Figure 6.5.2.7-----------------------------------------------------------------------------58









List of symbols/Abbreviations

S/N

ABBREVIATIONS

MEANING


1

OLAP

Online Analytical Processing


2

ROLAP

Relational online analytical processing


3

MOLAP

multidimensional online analytical processing


4

OLTP

online transaction processing


5

MOT

Ministry of Tourism Malaysia


6

SQL

Structured Query Language


7

CSV

comma-separated values


8

HTML

Hypertext Markup Language


9

PDF

Portable document format


10

RTF

Rich Text Format















TOURISM DATABASE MANAGEMENT SYSTEM USING DATA WAREHOUSE APPROACH
For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853

Share This
  • Type: Project
  • Department: Computer Science
  • Project ID: CPU2097
  • Access Fee: ₦5,000 ($14)
  • Pages: 65 Pages
  • Format: Microsoft Word
  • Views: 351
Payment Instruction
Bank payment for Nigerians, Make a payment of ₦ 5,000 to

Bank GTBANK
gtbank
Account Name Obiaks Business Venture
Account Number 0211074565

Bitcoin: Make a payment of 0.0005 to

Bitcoin(Btc)

btc wallet
Copy to clipboard Copy text

500
Leave a comment...

    Details

    Type Project
    Department Computer Science
    Project ID CPU2097
    Fee ₦5,000 ($14)
    No of Pages 65 Pages
    Format Microsoft Word

    Related Works

    ABSTRACT This project work intends to provide architecture for the technology in building of a standard, sophisticated and user-friendly data warehouse system which is platform independent and secured. The proposed work surely addressed the limitations identified within the scope of this project... Continue Reading
    ABSTRACT The project is the design and implementation of database federation of public database of Nigerians using database links and web services. It involves the design of a representative of the primary database that houses comprehensive information about Nigeria residences; other smaller databases representing some of the government agencies... Continue Reading
    ABSTRACT The project is the design and implementation of database federation of public database of Nigerians using database links and web services. It involves the design of a representative of the primary database that houses comprehensive information about Nigeria residences; other smaller databases representing some of the government agencies... Continue Reading
    ABSTRACT  Data warehousing and business intelligence are key enablers in the drive to harness management information and improve decision-making. They underpin the recent wave of interest in data mining and customer relationship management and create opportunities for performance improvements based on quantitative analysis at every level in an... Continue Reading
    INTRODUCTION The dictionary defines accident as “an unexpected and undesirable event, a mishap, unforeseen and without apparent cause. The mounting toll of Road Traffic Accident (RTA) deaths in Nigeria has public health problem, which requires urgent attention since these deaths are preventable. The pattern of scold sustained in these fatalities... Continue Reading
    CHAPTER ONE INTRODUCTION: This chapter gives an overview about the aim, objectives, background and operation environment of the system. 1.1 BACKGROUND OF THE STUDY Library ManagementSystem is an application which refers to library systems which are generally small or medium in... Continue Reading
    ABSTRACT In the early years, the use of humans and paper work in tracking distribution of goods was a norm but there was a gap in the chain process. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. Hence the need to replace... Continue Reading
    ABSTRACT In the early years, the use of humans and paper work in tracking distribution of goods was a norm but there was a gap in the chain process. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. Hence the need to replace... Continue Reading
    ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities involve the acquisition of data and processing. As exploration activities increases in the modern world, the computer manufacturers are also working hard to produce... Continue Reading
    ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities involve the acquisition of data and processing.  As exploration activities increases in the modern world, the computer manufacturers are also working hard to produce... Continue Reading
    Call Us
    whatsappWhatsApp Us